Access rights for tablespaces, phpPgAdmin versus PgAdmin
От | Kenneth Porter |
---|---|
Тема | Access rights for tablespaces, phpPgAdmin versus PgAdmin |
Дата | |
Msg-id | 30B2769BD722F9F4FD7848F2@[10.169.6.155] обсуждение исходный текст |
Ответы |
Re: Access rights for tablespaces, phpPgAdmin versus PgAdmin
|
Список | pgsql-novice |
I'm coming from MySQL and still trying to get my head around the PostgreSQL approach to authentication and access control. I got postgres installed on CentOS 5 with yum, started the server (which creates the initial database), and installed phpPgAdmin on the same server under Apache. I then installed PgAdmin 1.8.0 on my XP box on my LAN. Using psql, I created a login role with all rights except superuser. I got my head around pg_hba.conf so I can log into both phpPgAdmin and PgAdmin from my XP system using my new role account. I then proceeded to create a new database in which to copy existing tables from another (Windows-based) application. (I plan to use the ODBC connector.) (As I type this, I just tried this with phpPgAdmin and it worked. I'll continue, though....) PgAdmin refuses to let me create the new DB, telling me "permission denied for tablespace pg_default". Some googling suggests that this is intentional, that if one wants to create a new table one needs to change the default tablespace permissions to allow it, or create a new tablespace. So why does phpPgAdmin succeed, and PgAdmin fail? What's the correct procedure to follow here? (I don't need a separate tablespace at this time, although I don't have a problem with creating one.) Do I need to change permissions on pg_default, and if so, how? I don't see where I can change permissions on a tablespace in PgAdmin.
В списке pgsql-novice по дате отправления: